home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / operations.sql < prev    next >
Text File  |  2000-05-12  |  964b  |  25 lines
  1. /* RCSVER $Id: operations.sql,v 1.3 1999-03-19 09:48:55-06 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        operations.sql
  6. * Date:        02/17/1999
  7. * memo:        Randy Wood
  8. * Description:    Create the operations table. This table contains all
  9. *        users and their associated operator types.
  10. * Changes:
  11. ************************************************************************* */
  12. CREATE TABLE operations
  13. (
  14.     user_id        NUMBER(38)    /* ID of user */
  15.         CONSTRAINT ref1_operations REFERENCES users(user_id)
  16.         ON DELETE CASCADE,
  17.     op_type     NUMBER(38)    /* Type of user: driver, rev. servicer, etc. */
  18.         CONSTRAINT ref2_operations REFERENCES optypes(op_type)
  19.         ON DELETE CASCADE,
  20.     subsys_id    NUMBER(38)
  21.         CONSTRAINT ref3_operations REFERENCES subsystems(id)
  22.         ON DELETE CASCADE,
  23.     CONSTRAINT pk_operations PRIMARY KEY (user_id, subsys_id)
  24. );
  25.